USE [genshi]
GO

/****** Object:  View [dbo].[Character_Panel]    Script Date: 2022/5/3 20:45:27 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[Character_Panel](Name,Weapon,Flower,Feather,Sand,Cup,Head,Life,Attack,Defense,Mystery,Criticalhit,Criticaldamage,Treatment,Efficiency,Fire,Water,Thunder,Wind,Ice,Rock,
Physics)
AS
Select Name,Weapon,Flower,Feather,Sand,Cup,Head,Life + IncreaseLife + Life * LifePercentage,Attack + IncreaseAttack + Attack*AttackPercentage ,
Defense + IncreaseDefense + Defense * DefensePercentage,Mystery,Criticalhit,Criticaldamage,Treatment,Efficiency,Fire,Water,Thunder,Wind,Ice,Rock,Physics
FROM Assemble;
GO

